Yes, we can Pray for success, and expect God's (or HigherPower's) Blessings on it.
(You may be familiar with the Scripture to put God First, and all these other Things follow? That's good.)And in order to manifest Success, we have to step forward and take care of the practical things we will need on the way to our successes.
How much of this is fear is the fear of success (ladder, heights),
and how much of that is the anxiety belonging to the ~weird-awkwardness felt (and the overwhelm) when we even 'think' about taking the first practical steps? Beginning is an engaging experience? (pun).
We must 'position' ourselves, at the bottom of the ladder, and lift up our foot to place it on the first rung of that Ladder, Balance ourselves, then push with the other too, in order to START our climb?
It's one thing to think about it, and another to actually do it.
It's one thing to think about success and feel good about it, then another thing to commit with our whole heart, and do the practical actions towards it.
There's a 'shift' involved. Perhaps your fear is the 'transition' occurring within you in your preparing to ACT upon it?
You might want to really double-check INSIDE yourself too? There might be a part of you that knows 'why' you feel you might fail at this? You NEED that information 'before' you set off on your journey? There may be a tweak you need to do? You need to know for sure that THIS "IS" what you really really want inside. Not just 'desire' (like fame and fortune), but are you 'wanting' to sacrifice for it.
Are you really willing to put in the sweat and tears, the letting go of certain other things in order to FOCUS on your achieving that goal, actually going after that success you prize with no holds.
So, Ask yourself if this is what you really want?
Close your eyes, and IMAGINE that total-feeling that you've ALREADY achieved it?
Now, look back at yourself now... Do you have any advice to give you?
Do you LIKE "what" you're doing?
Did you enjoy the 'work' it took in order to get there?
Do you think you'd be willing to do that now?
Scripture says that God GIVES us the desires of our Heart.
Why don't you spend some time thinking and conversing with God again, about the desire?
Is it REALLY what you want?
Ask for Clarifications. It's okay to ask. AND, it's always okay to change your mind or direction. Life is long, but also very short.
Is it really "meant" for you to actually DO that vocation?
Or, is it rather 'the feeling' you imagine you would get (prestige, admiration, women, money, etc) IF you achieved it?
Concentrate on focusing 'the feeling' you want FROM the success. 'Own' it, and meditate/pray/hold-space with it for a while. See if your 'images' change.
You MIGHT just need to tweak 'the image' of what it is you think you want to do?
See how that sits with you for a while?
Be Extraordinary! and,
Be Extraordinarily Blessed!!!